CodGrantOrigination

EntityType | Independent
Logical Entity Name | CodGrantOrigination
Default Table Name | FaCODGrant
Logical Only | NO
Owner | dbo
Definition |
Note |

CodGrantOrigination Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
Id |  | INTEGER | NO |
FundSourceType |  | CHAR(8) | NO |
AwardYear |  | CHAR(7) | NO |
PellIdentifierCode |  | CHAR(6) | NO |
StudentIdentifier |  | VARCHAR(44) | NO |
GradeLevel |  | CHAR(1) | NO |
GrantIdentifier |  | CHAR(21) | NO |
GrantAmount |  | MONEY(19, 4) | NO |
EnrollmentDate |  | DATETIME | NO |
ACGEligibilityPaymentReasonCode |  | CHAR(2) | YES |
ACGRigorousHighSchoolProgramCode |  | CHAR(6) | YES |
SMARTCIPCode |  | CHAR(7) | YES |
OriginatedGrantAmount |  | MONEY(19, 4) | YES |
OriginatedEnrollmentdate |  | DATETIME | YES |
OriginatedACGEligibilityPaymentReasonCode |  | CHAR(2) | YES |
OriginatedACGRigorousHighSchoolProgramCode |  | CHAR(6) | YES |
OriginatedSMARTCIPCode |  | CHAR(7) | YES |
BatchIdentifier |  | VARCHAR(30) | YES |
OriginationStatus |  | CHAR(1) | NO |
OriginationDate |  | DATETIME | YES |
OriginationRejectCodes |  | VARCHAR(75) | YES |
LastModifiedUserId |  | INTEGER | NO |
CreatedDateTime |  | DATETIME | NO |
LastModifiedDateTime |  | DATETIME | NO |
ModFlag |  | CHAR(1) | NO |
RowVersion |  | TIMESTAMP/DATE | NO |
AtsIdentifier |  | VARCHAR(21) | YES |
ATSStatus |  | VARCHAR(12) | YES |
ATSLinkIndicator |  | VARCHAR(3) | YES |
ATSElectronicIndicator |  | VARCHAR(3) | YES |
IsTeacherExpertIndicator |  | BIT | YES |
TotalEligibilityUsed |  | MONEY(19, 4) | YES |
IsAdminRelief |  | BIT | NO |
BookDate |  | DATETIME | YES |
BookStatus |  | CHAR(1) | YES |

CodGrantOrigination Keys

Key Name | Key Type | Keys
FaCODGrant_OriginationBatchID_N_N_IDX | Inversion Entry | BatchIdentifier
FaCODGrant_FinancialAwardID_U_N_IDX | Alternate Key | GrantIdentifier
FaCODGrant_StudentIdentifier_N_N_IDX | Inversion Entry | StudentIdentifier
UK_FaCODGrant_FundSourceType_AwardYear_PellID_StudentIdentifier_LevelInCollege_FinancialAwardID | Alternate Key | FundSourceType, AwardYear, PellIdentifierCode, StudentIdentifier, GradeLevel, GrantIdentifier
FaCODGrant_UserID_N_N_IDX | Inversion Entry | LastModifiedUserId
FaCODGrant_FaCODGrantID_U_C_IDX | PrimaryKey | Id

CodGrantOrigination Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
Staff | Non-Identifying | One To Zero or More |  |  |  | LastModifiedUserId | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype
CodGrantDisbursement | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentAward | Non-Identifying | One To Zero or More |  |  |  |  | NO

CodGrantOrigination Check Constraints

Check Constraint Name | CheckConstraint

CodGrantOrigination Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.CodGrantOrigination | NO |  |  |
Physical (Microsoft SQL Server) dbo.FaCODGrant | NO |  |  |

CodGrantOrigination Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Financial Aid

CodGrantOrigination Data Movement Rules

Name | Type | Rule Text/Value